set hive.exec.dynamic.partition=true;            --  动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=90;         --  每天生成 60 个分区
set hive.exec.max.dynamic.partitions.pernode=90; --  每天生成 60 个分区

insert overwrite table jms_dim.dim_t_ass_sorting_equipment_dt
select
 id
 ,equipment_name
 ,owned_venue_name
 ,owned_venue_code
 ,supplier_code
 ,supplier_name
 ,equipment_code
 ,equipment_layer
 ,infeed_area
 ,for_charter_num
 ,lattice_num
 ,trolley_num
 ,docking_time
 ,create_time
 ,update_time
 ,ext_info
 ,ext_info1
 ,valid
 ,owned_venue_type
 ,agency_area_name
 ,agency_area_code
 ,franchisee_name
 ,franchisee_code
 ,create_user
 ,update_user
 ,equipment_type
 ,dt
from jms_ods.t_ass_sorting_equipment
where dt= '{{ execution_date | cst_ds }}'
distribute by 1 ;